package com.neusoft.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.neusoft.vo.AttendListSearchVO;
import com.neusoft.vo.AttendListVO;

public interface AttendListMapper {
	@Select("SELECT a.date,c.date_type, a.state, a.clockIn_time as t1, a.clockOut_time as t2, r.clockIn_time as t3, r.clockOut_time as t4, r.restate\r\n"
			+ "FROM attendance a LEFT JOIN reattendace r ON a.date = r.date\r\n"
			+ "			JOIN calendar c ON	a.date = c.date\r\n"
			+ "WHERE a.empno = #{empno}\r\n"
			+ "AND YEAR(a.date) = #{year} AND MONTH(a.date) = #{month}")
	public List<AttendListVO> getAttendList(AttendListSearchVO vo);
}
